<%-- 
    Document   : updateresult
    Created on : Apr 11, 2012, 5:20:28 PM
    Author     : project
--%>

<%@page contentType="text/html" pageEncoding="UTF-8"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
    "http://www.w3.org/TR/html4/loose.dtd">

<%@page import="java.sql.*"%>
<%@page import="jobportal.Dbconn" %>
<%@include file="header.jsp" %>
<%
            Connection con = Dbconn.getConn();
            Statement st = con.createStatement();
            ResultSet rs = st.executeQuery("select jobs.jobid,jobtitle,walkindate,venue  from jobs,job_applied where  jobs.jobid=job_applied.jobid and  compid='" + session.getAttribute("username") + "' and result is null and walkindate<now() group by jobid having count(*)>0");
%>



<table width="100%" border="0" cellpadding="0" cellspacing="0">
    <tr>
        <td align="left" valign="top">

            <span class='messagesred' style="text-align:center">
            </span>

            <table width="80%" border="0" cellspacing="0" >
                <tr>
                    <td width="100%" align="left" valign="top"><span class="mainheading_emp" style="margin-bottom:10px;">View Student Application Details</span></td>
                </tr>
                <tr>
                    <td height="10" align="left" valign="top" class="normal"></td>
                </tr>
                <tr>
                    <td height="26" align="left" valign="top" class="normal"><table width="100%" border="0" cellspacing="2"  class="tbl_bdr">
                            <tr class="sde_mnu_hdr_blue" >
                                <td width="2%" align="left" valign="middle"><img style="margin-top:-5px; margin-left:-5px;" src="../images/top_left.gif";/></td>
                                <td width="10%" align="left" valign="middle" class="subjeading">&nbsp;</td>
                                <td width="16%" align="left" valign="middle" class="subjeading">&nbsp;</td>
                                <td width="22%" align="left" valign="middle" class="subjeading">&nbsp;</td>
                                <td width="25%" align="left" valign="middle" class="subjeading">&nbsp;</td>
                                <td width="25%" align="left" valign="middle" class="subjeading">&nbsp;</td>
                            </tr>
                            <tr class="sde_mnu_hdr_blue" style="background-color: skyblue">
                                <td width="2%" align="left" valign="middle">&nbsp;</td>
                                <td width="10%" align="left" valign="middle" class="subjeading">Job id</td>
                                <td width="16%" align="left" valign="middle" class="subjeading">Job Title</td>
                                <td width="22%" align="left" valign="middle" class="subjeading">Exam Date</td>
                                <td width="25%" align="left" valign="middle" class="subjeading">Venue</td>
                                <td width="25%" align="left" valign="middle" class="subjeading">Action</td>
                            </tr>

                            <%while (rs.next()) {%>
                            <tr class="greybg">
                                <td height="56" align="center" valign="top">&nbsp;</td>
                                <td align="left" valign="top" class="link"><a href="view_posted_jobs_emp.jsp?jobid=<%=rs.getString("jobid")%>" title="Update Result "><%= rs.getString("jobid")%></a></td>
                                <td align="left" valign="top"><%= rs.getString("jobtitle")%></td>
                                <td align="left" valign="top"><a href="job_delete_code.jsp?memid=62" onclick="javascript: return confirm('All the  information related to this Job Postings will be deleted.\n\nDo you really want to delete the Job Posting?');"></a></span><%=rs.getString("walkindate")%></td>
                                <td align="left" valign="top"><a href="job_delete_code.jsp?memid=62"></a>              <font color='red'><%= rs.getString("venue")%></font>          </td>
                                <td align="left" valign="top">

                                    <a href="result.jsp?jobid=<%=rs.getString("jobid")%>" title="Update result"><input id="submit" name="submit" type="submit" value="Update Result" class="button2" style="width:100px; height:20px;"></a>
                                </td>
                            </tr>
                            <%}
            if (rs.last()) {
            }%>
                            <tr >
                                <td colspan="6" height="2">&nbsp;</td>
                            </tr>
                            <tr class="sde_mnu_hdr_blue" style="background-color: skyblue">
                                <td width="2%" align="left" valign="middle"></td>
                                <td width="10%" align="center" valign="middle" class="subjeading" colspan="5"><%= rs.getRow() + " Result Found"%></td>

                            </tr>
                        </table></td>
                </tr>
            </table></td>
    </tr>
</table>
<%@include file="footer.jsp" %>

